General Ledger Journal Listing

This report will show posted journal vouchers based on the selections entered.

NAVIGATION: REPORTS menu > General Ledger Reports > Journal Listing

  1. Sort Information
    1. Sort the information on the generated report by one of the following options:
      1. Account Number - sort by account number order
      2. Journal Entry Number - sort by journal number
      3. Source - sort by source
      4. Transaction Date - sort by transaction date.
    2. The selected sort option will have a great effect on how long it takes to run this report.
    3. Pick the sort option that will have the specific information you are trying to find.
    4. For example, if looking for Journal Entry Number 1897 - 1899 select Journal Entry Number as the sort option.  If looking for transaction date 6/30/2023, then select Transaction Date as the sort option.
  2. Account Selection: Enter or select an account range to restrict the report to the selected accounts, or leave blank for all accounts.
  3. First Account
    1. Enter or select an account to begin the report with, or leave this field blank to begin with the first account.
    2. If an account number is entered in this field and the last account field is left blank, the report will only be for the account number entered in the first account field.
  4. Last Account
    1. Enter or select an account to end the report with, or leave this field blank to end with the last account.
    2. If the first account field is left blank and an account number is entered into the last account field, the report will begin with the very first active account and end with the account entered as the last account.
  5. Source Selection
    1. A source may be entered for each line of a journal voucher.
    2. Some sources are generated during a posting process and interfaced into the general ledger.
    3. For Example: When Accounts Payable Vouchers are posted the journal entries that are created will have a source of AP.  When payroll is posted the journal entries that are created will have a source of PR. If both source fields are left blank the generated report will include all sources.
  6. First Source
    1. Enter a source to begin the report with, or leave the field blank.
    2. If a source is entered into the first source field and the last source field is left blank, the report will be generated for the first source only.
  7. Last Source
    1. Enter a source to end the report with, or leave the field blank.
    2. If a source is entered into the last source field and the first source is left blank, the report will include all sources up to the one entered as the last source.
  8. Journal Selection
    1. Enter journal entry numbers into the field to generate a report based on JV numbers.
    2. If both first and last journal fields are left blank the report will include all journal numbers within the other specifications selected.
  9. First Journal
    1. Enter a journal number into the first journal field to begin the report with the information from it.
    2. If the last journal field is left blank, the report will be for the journal number entered as the first journal number.
    3. If a last journal number is entered, the report will be for all journal entries that are in the range.
  10. Last Journal
    1. Enter a journal number into the last journal field to end the report with it, or leave the field blank.
    2. If a journal number is entered in the last journal field and the first journal field is left blank, the report will include all journal numbers within the other selection criteria up to and including the journal number entered.
  11. Date Selection: Select one of the following:
    1. All
    2. This Month
    3. Last Month
    4. This Quarter
    5. Last Quarter
    6. 1st Quarter
    7. 2nd Quarter
    8. 3rd Quarter
    9. 4th Quarter
    10. This Year
    11. This Year to Date
    12. Last Year
    13. Last Year to Date
    14. Custom  (allows you to select your own dates)
  12. Start Date and End Date: Based on the date criteria selected, the start and end date will automatically fill in a date range with the following exceptions:  
    1. If Custom is selected the start and end dates will be blank allowing the user to enter a "custom" date range.
    2. If All is selected, the beginning date is left blank and the ending date will be the current date.
    3. Displayed date ranges may be edited.
  13. Memo Closing: Select one of the following Memo options:
    1. Do Not Include
    2. Include
    3. Only Memo Entries
  14. Print, preview, or save the report (see Report Preview, Print and Save Options).
  15. SAMPLE

12/2023

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388